package com.pojo;

import java.util.ArrayList;
import java.util.List;

public class JdInventoryExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public JdInventoryExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andI_numIsNull() {
            addCriterion("i_num is null");
            return (Criteria) this;
        }

        public Criteria andI_numIsNotNull() {
            addCriterion("i_num is not null");
            return (Criteria) this;
        }

        public Criteria andI_numEqualTo(Integer value) {
            addCriterion("i_num =", value, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numNotEqualTo(Integer value) {
            addCriterion("i_num <>", value, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numGreaterThan(Integer value) {
            addCriterion("i_num >", value, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numGreaterThanOrEqualTo(Integer value) {
            addCriterion("i_num >=", value, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numLessThan(Integer value) {
            addCriterion("i_num <", value, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numLessThanOrEqualTo(Integer value) {
            addCriterion("i_num <=", value, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numIn(List<Integer> values) {
            addCriterion("i_num in", values, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numNotIn(List<Integer> values) {
            addCriterion("i_num not in", values, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numBetween(Integer value1, Integer value2) {
            addCriterion("i_num between", value1, value2, "i_num");
            return (Criteria) this;
        }

        public Criteria andI_numNotBetween(Integer value1, Integer value2) {
            addCriterion("i_num not between", value1, value2, "i_num");
            return (Criteria) this;
        }

        public Criteria andP_idIsNull() {
            addCriterion("p_id is null");
            return (Criteria) this;
        }

        public Criteria andP_idIsNotNull() {
            addCriterion("p_id is not null");
            return (Criteria) this;
        }

        public Criteria andP_idEqualTo(String value) {
            addCriterion("p_id =", value, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idNotEqualTo(String value) {
            addCriterion("p_id <>", value, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idGreaterThan(String value) {
            addCriterion("p_id >", value, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idGreaterThanOrEqualTo(String value) {
            addCriterion("p_id >=", value, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idLessThan(String value) {
            addCriterion("p_id <", value, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idLessThanOrEqualTo(String value) {
            addCriterion("p_id <=", value, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idLike(String value) {
            addCriterion("p_id like", value, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idNotLike(String value) {
            addCriterion("p_id not like", value, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idIn(List<String> values) {
            addCriterion("p_id in", values, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idNotIn(List<String> values) {
            addCriterion("p_id not in", values, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idBetween(String value1, String value2) {
            addCriterion("p_id between", value1, value2, "p_id");
            return (Criteria) this;
        }

        public Criteria andP_idNotBetween(String value1, String value2) {
            addCriterion("p_id not between", value1, value2, "p_id");
            return (Criteria) this;
        }

        public Criteria andW_idIsNull() {
            addCriterion("w_id is null");
            return (Criteria) this;
        }

        public Criteria andW_idIsNotNull() {
            addCriterion("w_id is not null");
            return (Criteria) this;
        }

        public Criteria andW_idEqualTo(Integer value) {
            addCriterion("w_id =", value, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idNotEqualTo(Integer value) {
            addCriterion("w_id <>", value, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idGreaterThan(Integer value) {
            addCriterion("w_id >", value, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idGreaterThanOrEqualTo(Integer value) {
            addCriterion("w_id >=", value, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idLessThan(Integer value) {
            addCriterion("w_id <", value, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idLessThanOrEqualTo(Integer value) {
            addCriterion("w_id <=", value, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idIn(List<Integer> values) {
            addCriterion("w_id in", values, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idNotIn(List<Integer> values) {
            addCriterion("w_id not in", values, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idBetween(Integer value1, Integer value2) {
            addCriterion("w_id between", value1, value2, "w_id");
            return (Criteria) this;
        }

        public Criteria andW_idNotBetween(Integer value1, Integer value2) {
            addCriterion("w_id not between", value1, value2, "w_id");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumIsNull() {
            addCriterion("i_InventoryNum is null");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumIsNotNull() {
            addCriterion("i_InventoryNum is not null");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumEqualTo(Integer value) {
            addCriterion("i_InventoryNum =", value, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumNotEqualTo(Integer value) {
            addCriterion("i_InventoryNum <>", value, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumGreaterThan(Integer value) {
            addCriterion("i_InventoryNum >", value, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("i_InventoryNum >=", value, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumLessThan(Integer value) {
            addCriterion("i_InventoryNum <", value, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumLessThanOrEqualTo(Integer value) {
            addCriterion("i_InventoryNum <=", value, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumIn(List<Integer> values) {
            addCriterion("i_InventoryNum in", values, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumNotIn(List<Integer> values) {
            addCriterion("i_InventoryNum not in", values, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumBetween(Integer value1, Integer value2) {
            addCriterion("i_InventoryNum between", value1, value2, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_InventoryNumNotBetween(Integer value1, Integer value2) {
            addCriterion("i_InventoryNum not between", value1, value2, "i_InventoryNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumIsNull() {
            addCriterion("i_outNum is null");
            return (Criteria) this;
        }

        public Criteria andI_outNumIsNotNull() {
            addCriterion("i_outNum is not null");
            return (Criteria) this;
        }

        public Criteria andI_outNumEqualTo(Integer value) {
            addCriterion("i_outNum =", value, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumNotEqualTo(Integer value) {
            addCriterion("i_outNum <>", value, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumGreaterThan(Integer value) {
            addCriterion("i_outNum >", value, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("i_outNum >=", value, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumLessThan(Integer value) {
            addCriterion("i_outNum <", value, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumLessThanOrEqualTo(Integer value) {
            addCriterion("i_outNum <=", value, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumIn(List<Integer> values) {
            addCriterion("i_outNum in", values, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumNotIn(List<Integer> values) {
            addCriterion("i_outNum not in", values, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumBetween(Integer value1, Integer value2) {
            addCriterion("i_outNum between", value1, value2, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_outNumNotBetween(Integer value1, Integer value2) {
            addCriterion("i_outNum not between", value1, value2, "i_outNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumIsNull() {
            addCriterion("i_InpNum is null");
            return (Criteria) this;
        }

        public Criteria andI_InpNumIsNotNull() {
            addCriterion("i_InpNum is not null");
            return (Criteria) this;
        }

        public Criteria andI_InpNumEqualTo(Integer value) {
            addCriterion("i_InpNum =", value, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumNotEqualTo(Integer value) {
            addCriterion("i_InpNum <>", value, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumGreaterThan(Integer value) {
            addCriterion("i_InpNum >", value, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("i_InpNum >=", value, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumLessThan(Integer value) {
            addCriterion("i_InpNum <", value, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumLessThanOrEqualTo(Integer value) {
            addCriterion("i_InpNum <=", value, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumIn(List<Integer> values) {
            addCriterion("i_InpNum in", values, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumNotIn(List<Integer> values) {
            addCriterion("i_InpNum not in", values, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumBetween(Integer value1, Integer value2) {
            addCriterion("i_InpNum between", value1, value2, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_InpNumNotBetween(Integer value1, Integer value2) {
            addCriterion("i_InpNum not between", value1, value2, "i_InpNum");
            return (Criteria) this;
        }

        public Criteria andI_stateIsNull() {
            addCriterion("i_state is null");
            return (Criteria) this;
        }

        public Criteria andI_stateIsNotNull() {
            addCriterion("i_state is not null");
            return (Criteria) this;
        }

        public Criteria andI_stateEqualTo(Integer value) {
            addCriterion("i_state =", value, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateNotEqualTo(Integer value) {
            addCriterion("i_state <>", value, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateGreaterThan(Integer value) {
            addCriterion("i_state >", value, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateGreaterThanOrEqualTo(Integer value) {
            addCriterion("i_state >=", value, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateLessThan(Integer value) {
            addCriterion("i_state <", value, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateLessThanOrEqualTo(Integer value) {
            addCriterion("i_state <=", value, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateIn(List<Integer> values) {
            addCriterion("i_state in", values, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateNotIn(List<Integer> values) {
            addCriterion("i_state not in", values, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateBetween(Integer value1, Integer value2) {
            addCriterion("i_state between", value1, value2, "i_state");
            return (Criteria) this;
        }

        public Criteria andI_stateNotBetween(Integer value1, Integer value2) {
            addCriterion("i_state not between", value1, value2, "i_state");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}